Text Columns

UCASE(<column>) - converts column to upper case

LCASE(<column>) - converts column to lower case

PROPER(<column>) - returns a column's data in lower case but with a leading capital

LEFT(<column>,<number>) - takes left <number> characters of column

RIGHT(<column>,<number>) - takes right <number> characters of column

STRIP(<column>) - removes all spaces from column

SOUNDS(<column>) - removes all vowels (plus Y) and spaces from column

LEN(<column>) - returns the length of each of the column's records

LTRIM - removes spaces to the left of the string (beginning)

RTRIM - removes spaces to the right of the string (end)

CODE(<column>) - returns the ASCII code of the first character in the column

CHR(<column>) - returns the ASCII character represented by a numeric column (mod 256)

INSTR(<column>,<string>) - returns the position in the column of the characters specified by the string

• NSQL Functions Overview
  • NSQL Functions A to Z
  • NSQL Intrinsic Functions
  • DATE Columns
  • Distance Calculations
  • Miscellaneous Functions
  • NUMERIC Columns
  • Text Columns
  • TIME Columns